﻿if exists (select 1
            from  sysobjects
           where  id = object_id('GXBZ_EMR_RYJL')
            and   type = 'U')
   drop table GXBZ_EMR_RYJL
go

/*==============================================================*/
/* Table: GXBZ_EMR_RYJL                                         */
/*==============================================================*/
create table GXBZ_EMR_RYJL (
   ZYLSH                varchar(64)          not null,
   XGBZ                 varchar(1)           not null,
   GRJBXXBSH            varchar(64)          not null,
   CXJMJKDABH           varchar(17)          not null,
   ZYHBS                varchar(64)          null,
   CJSJ                 datetime             null,
   JDYSGH               varchar(64)          null,
   JDYSXM               varchar(32)          null,
   BSCSZSFZH            varchar(32)          null,
   YHZDGXDM             varchar(2)           null,
   YHZDGXMC             varchar(100)         null,
   BSCSZXM              varchar(30)          null,
   WDGLJGDM             varchar(22)          null,
   WDGLJGMC             varchar(70)          null,
   ZZSHRGH              varchar(64)          null,
   ZZSHRXM              varchar(30)          null,
   JZYSGH               varchar(64)          null,
   JZYSXM               varchar(30)          null,
   ZYYSGH               varchar(64)          null,
   ZYYSXM               varchar(30)          null,
   ZZYSGH               varchar(64)          null,
   ZZYSXM               varchar(30)          null,
   RYSJ                 datetime             null,
   BCH                  varchar(20)          null,
   BCHMC                varchar(100)         null,
   BFH                  varchar(20)          null,
   BFHMC                varchar(100)         null,
   RYKSBM               varchar(64)          null,
   RYKSMC               varchar(32)          null,
   RYBQBM               varchar(20)          null,
   RYBQMC               varchar(100)         null,
   JZYYBM               varchar(22)          null,
   JZYYMC               varchar(70)          null,
   ZSMS                 varchar(1024)        null,
   XBSMS                varchar(1024)        null,
   JWSBZ                varchar(1)           null,
   JWSMS                varchar(1024)        null,
   CRBBZ                varchar(1)           null,
   CRBMS                varchar(1024)        null,
   HYSMS                varchar(1024)        null,
   GMSMS                varchar(1024)        null,
   SSSMS                varchar(1024)        null,
   YFJZSMS              varchar(1024)        null,
   SXSMS                varchar(1024)        null,
   GRSMS                varchar(1024)        null,
   YJSMS                varchar(1024)        null,
   JZSMS                varchar(1024)        null,
   RYTW                 decimal(4,1)         null,
   RYMB                 decimal(4,1)         null,
   RYHXPL               decimal(3,0)         null,
   RYSSY                decimal(3,0)         null,
   RYSZY                decimal(3,0)         null,
   RYSG                 decimal(5,2)         null,
   RYTZ                 decimal(5,2)         null,
   YBZKJCJG             varchar(1024)        null,
   PFHNMJCJG            varchar(1024)        null,
   QSQMLBJCJG           varchar(1024)        null,
   TBJQQGJCJG           varchar(1024)        null,
   JBJCJG               varchar(1024)        null,
   XBJCJG               varchar(1024)        null,
   FBJCJG               varchar(1024)        null,
   GMZZJCJG             varchar(1024)        null,
   WSZQJCJG             varchar(1024)        null,
   JZJCJG               varchar(1024)        null,
   SZJCJG               varchar(1024)        null,
   SJXTJCJG             varchar(1024)        null,
   ZKQKMS               varchar(1024)        null,
   FZJCJG               varchar(1024)        null,
   CSNRKKBZ             varchar(1024)        null,
   XYCZDRQ              datetime             null,
   XYCZDM               varchar(10)          null,
   XYCZMC               varchar(100)         null,
   XYCZRYZDSW           int                  null,
   ZYSZGCJG             varchar(1024)        null,
   ZYCZRQ               datetime             null,
   ZYCZBM               varchar(100)         null,
   ZYCZBMDM             varchar(10)          null,
   ZYCZZHMC             varchar(100)         null,
   ZYCZZHDM             varchar(10)          null,
   ZYCZRYZDSW           int                  null,
   XYXZZDRQ             datetime             null,
   XYXZZDMC             varchar(100)         null,
   XYXZZDDM             varchar(10)          null,
   XYXZRYZDSW           int                  null,
   ZYXZZDRQ             datetime             null,
   ZYXZZDMC             varchar(100)         null,
   ZYXZZDDM             varchar(10)          null,
   ZYXZHZMC             varchar(100)         null,
   ZYXZHZDM             varchar(10)          null,
   ZYXZRYZDSW           int                  null,
   XYQDZDRQ             datetime             null,
   XYQDZDMC             varchar(100)         null,
   XYQDZDDM             varchar(10)          null,
   XYQZZDSW             int                  null,
   ZYQDZDRQ             datetime             null,
   ZYQDZDDM             varchar(10)          null,
   ZYQDZDMC             varchar(100)         null,
   ZYQDZHMC             varchar(100)         null,
   ZYQDZHDM             varchar(10)          null,
   ZYQZRYSW             int                  null,
   XYBCZDRQ             datetime             null,
   XYBCZDMC             varchar(100)         null,
   XYBCZDDM             varchar(10)          null,
   XYBCZDRYSW           int                  null,
   ZZZF                 varchar(100)         null,
   MJ                   varchar(16)          not null,
   TBRQ                 datetime             not null,
   SCZT                 varchar(1)           not null,
   CS_JYBZ              int                  not null,
   SCSJ                 datetime             not null,
   constraint PK_GXBZ_EMR_RYJL primary key (ZYLSH, XGBZ)
)
go
